package com.bhprod.comatule.db;

public class DBConstants {

	// Species
	public final static String SPECIES_TABLE = "species";
	public final static String SPECIES_COL_ID = "species_id";
	public final static String SPECIES_COL_NAME = "species_name";
	public final static String SPECIES_COL_TAXON_ID = "taxon_id";
	public final static String SPECIES_COL_DESCRIPTION = "species_description";
	public final static String SPECIES_COL_ANECDOTE = "species_anecdote";

	// FrenchSpeciesNames
	public final static String FRENCH_SPECIES_NAMES_TABLE = "french_species_names";
	public final static String FRENCH_SPECIES_NAMES_COL_ID = "french_name_id";
	public final static String FRENCH_SPECIES_NAMES_COL_SPECIES_ID = "species_id";
	public final static String FRENCH_SPECIES_NAMES_COL_NAME_TEXT = "french_name_text";
	public final static String FRENCH_SPECIES_NAMES_COL_NAME_FIRST = "french_name_first";

	// CriterionSpecies
	public final static String CRITERION_SPECIES_TABLE = "criterion_species";
	public final static String CRITERION_SPECIES_COL_ID = "criterion_species_id";
	public final static String CRITERION_SPECIES_COL_SPECIES_ID = "species_id";
	public final static String CRITERION_SPECIES_COL_TEXT = "criterion_species_text";

	// Photo
	public final static String PHOTO_TABLE = "photo";
	public final static String PHOTO_COL_ID = "photo_id";
	public final static String PHOTO_COL_SPECIES_ID = "species_id";

	// Taxon
	public final static String TAXON_TABLE = "taxon";
	public final static String TAXON_COL_ID = "taxon_id";
	public final static String TAXON_COL_NAME = "taxon_name";
	public final static String TAXON_COL_PARENT_ID = "taxon_parent_id";
	public final static String TAXON_COL_DESCRIPTION = "taxon_short_description";
	public final static String TAXON_COL_CHILDREN_TEXT = "taxon_children_text";

	// CriterionTaxon
	public final static String CRITERION_TAXON_TABLE = "criterion_taxon";
	public final static String CRITERION_TAXON_COL_ID = "criterion_taxon_id";
	public final static String CRITERION_TAXON_COL_TAXON_ID = "taxon_id";
	public final static String CRITERION_TAXON_COL_TEXT = "criterion_taxon_text";

}
